package com.first.util;

import com.alibaba.druid.sql.repository.SchemaObjectType;
import com.alibaba.fastjson.JSON;
import com.first.dao.impl.StatisticsDaoImpl;
import org.springframework.beans.factory.annotation.Autowired;

import java.text.SimpleDateFormat;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;


public class test {
    public static void main(String[] args) {
        StringBuilder builder = new StringBuilder("SELECT *  from b_order where  orderstatus= 3");
        List<Map> maps;
//        if (bOrder.getOrderid() != null && !"".equals(bOrder.getOrderid())) {
//            builder.append(" and orderid like '%" + bOrder.getOrderid() + "%'  ");
//            maps = DBUtil.queryListMap(builder.toString());
//        } else {

            maps = DBUtil.queryListMap(builder.toString());
        System.out.println(maps.size());



//        String sql2 = "select sum(t_price) from b_order_wj bow,b_order bo WHERE bo.orderstatus=4 and bow.orderid=bo.orderid and bo.storagedate BETWEEN ? and ?";
//        List<List> lists2 = DBUtil.queryList(sql2, start, end);
//        System.out.println(lists2.get(0).get(0) !=null);
//        System.out.println(lists2);
//        System.out.println(lists2);
//        Echarts echarts2 = new Echarts();
//        echarts2.setName("采购额");
//        echarts2.setValue((Double) lists2.get(0).get(0));
//        System.out.println(echarts2);
//        echartss.add(echarts1);
//        echartss.add(echarts2);
//        System.out.println(echartss);


    }


}

